UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tshsshVc+8kq9tZfDjzWk/N0Jfy3Ke8yC5bHUDer1T0='
WHERE
key_id = 'bcf8cc4a76a782383cd580d1a81b2ef5272562082683cd88f0ab263e7f42989c'
AND (
token = 'tshsshVc+8kq9tZfDjzWk/N0Jfy3Ke8yC5bHUDer1T0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)