UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bQKE9Dy/ZCJSxbKsM8d7OfMW7/8YEE7p7fyJsFCk9F8='
WHERE
key_id = 'e67df40e9031d727c06e0142c57b32e47ddfb7593a13013b27870547a3401c46'
AND (
token = 'bQKE9Dy/ZCJSxbKsM8d7OfMW7/8YEE7p7fyJsFCk9F8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)