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