UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnXJlGkX5j309ySJYK7USLqDOajlHiKwbodSQ3+1tW0='
WHERE
key_id = 'a91a72f9189ab23743269600a1f433cbf579393ab90a9bf8091af79420eb0e75'
AND (
token = 'KnXJlGkX5j309ySJYK7USLqDOajlHiKwbodSQ3+1tW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)