UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DCwdqVxKYx+HEwfHPUiB+SJxawcZPSMl3UjrCQBvicE='
WHERE
key_id = 'b9916ee6bafbc4f65e5b6e5b534b2c207ada71021dae9de68909af7d2a56b94d'
AND (
token = 'DCwdqVxKYx+HEwfHPUiB+SJxawcZPSMl3UjrCQBvicE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)