UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDDG8djFTw5sCNz09nY5ZpkY7NOnrfO6g4spuPzlrdY='
WHERE
key_id = '16668f9115f8987bcde8c3f966eacbf48c51c3e5387766705809e3c358c19268'
AND (
token = 'zDDG8djFTw5sCNz09nY5ZpkY7NOnrfO6g4spuPzlrdY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)