UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kgiXcCDh4OwjxCn0o1nC7W+0G952Mh+mJcaXVCHI558='
WHERE
key_id = '79af42cfcfc96f20f820d910eebac3fa135431c1fddf0deee3db34fd89cef192'
AND (
token = 'kgiXcCDh4OwjxCn0o1nC7W+0G952Mh+mJcaXVCHI558='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)