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