UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'huowXUzdp5vQAfM1NaYI/E7IWwFtVNdH5x3ESJoKXT4='
WHERE
key_id = '6c1bb939ab65c83b53947a2bf7e36c4e86c08fbd5ad6208a4f0577e796a6ced8'
AND (
token = 'huowXUzdp5vQAfM1NaYI/E7IWwFtVNdH5x3ESJoKXT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)