UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r1C+lO6xbxd39OUfpfvTxJZVmEHh5m8ssZEwS1wyhis='
WHERE
key_id = 'ad55c0cdb114940493632d1b60a54a0a82ebf23a1650f8a9a5e8f13b2042ef00'
AND (
token = 'r1C+lO6xbxd39OUfpfvTxJZVmEHh5m8ssZEwS1wyhis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)