UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n782/oZUdme4IARbe6cUegVQGprA8sBOX5BNl9vsHqI='
WHERE
key_id = '4fb4a46e0c68cae863a4ce6c7dc3812351c2fbd4a455e24dcfe5735d4a077371'
AND (
token = 'n782/oZUdme4IARbe6cUegVQGprA8sBOX5BNl9vsHqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)