UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vBO6uTojMsFcsFmjkyq3TJ4VmYBr2wpUCIS6A9nlQw8='
WHERE
key_id = 'bcb8e8bdc69216feb7d6c0e617559ec6fbeb349cb12b018053f55c9ef53faae5'
AND (
token = 'vBO6uTojMsFcsFmjkyq3TJ4VmYBr2wpUCIS6A9nlQw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)