UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xja8tsx1iQU3d1eygMVWlU7qR7LJhrhjJxCexU6g2u8='
WHERE
key_id = '8550297905239381656747b43fb519a22a01c50499926156e0f4d4318f55198a'
AND (
token = 'xja8tsx1iQU3d1eygMVWlU7qR7LJhrhjJxCexU6g2u8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)