UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YMc1VfzCbW0Eh6lGxVMrh85Q2PBKYemYmcCq3lxxLeg='
WHERE
key_id = '7d5cba52a168566a6ea3d9e8d9d28a393434f70f5c5dd4581f98afd5f877a981'
AND (
token = 'YMc1VfzCbW0Eh6lGxVMrh85Q2PBKYemYmcCq3lxxLeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)