UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f+jfZNvq/5SwR+7nwak6lufptUAAxmKRB4ns6dc/v14='
WHERE
key_id = '8b9c697b635fb28451bffd217181fd99fc167e9963a28aca3323085ea7c07cad'
AND (
token = 'f+jfZNvq/5SwR+7nwak6lufptUAAxmKRB4ns6dc/v14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)