UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQ9E1lZ+BMOQ86IKHvqsQBI7OzydNQk1HDJkFWmNlgM='
WHERE
key_id = '9abd8d6ed80f5d0f4b03887fc54cacc6225cc2e9329aa111b21511f5d4292ce8'
AND (
token = 'zQ9E1lZ+BMOQ86IKHvqsQBI7OzydNQk1HDJkFWmNlgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)