UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/0hSlUl42Xc5Xhu60AoZEy13WOtj8sqK9HdbUi8CBCw='
WHERE
key_id = '8087b7a0bb6e846603a92d621b4baf90e33694ff4f77456c6edae5fff8e1ca70'
AND (
token = '/0hSlUl42Xc5Xhu60AoZEy13WOtj8sqK9HdbUi8CBCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)