UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cNNp4aCfxPgZVQqasnQV9SbE8O4M/lL+iXaQaf6zZS8='
WHERE
key_id = 'c61914a1f8dc8c076a16d08d04738eb4bb2fed28c2048402982d76268b47e192'
AND (
token = 'cNNp4aCfxPgZVQqasnQV9SbE8O4M/lL+iXaQaf6zZS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)