UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QWWZqaGqx+7K+AA8rn/qW8TeF9BJN3WObU7Eufl05To='
WHERE
key_id = 'b8f410fc46723ac16efd5bd02b66a48da4ee926813c78308248ac604db72b60a'
AND (
token = 'QWWZqaGqx+7K+AA8rn/qW8TeF9BJN3WObU7Eufl05To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)