UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lxfs1OgyNCtcf1/axpa20a8IlkrHyjtPBCHu2+daKXQ='
WHERE
key_id = '5a4976c856afa1bad98a6e26587e2775cafd33037ed4bcffee8d362b09b95fc2'
AND (
token = 'lxfs1OgyNCtcf1/axpa20a8IlkrHyjtPBCHu2+daKXQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)