UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9KJNe67LYCDUj0cVHZyQs8es3Nv7thHtMvki1cjZUmE='
WHERE
key_id = '7c3bf833881c5749b079c0acd773ef41657f169b0bb095beb8375365d3f75838'
AND (
token = '9KJNe67LYCDUj0cVHZyQs8es3Nv7thHtMvki1cjZUmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)