UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V3d/NU1qMpHQBsWhznGfDOTBIFi63m7Tvk4z2gfgpYE='
WHERE
key_id = '5c7af0a7414fa369e455783f17461e701a8545720be7b1c657c5a8734596300e'
AND (
token = 'V3d/NU1qMpHQBsWhznGfDOTBIFi63m7Tvk4z2gfgpYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)