UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0/vnrEsEIwFiFMBot3z/eq3NyxCM80OFs8tK4sziCE8='
WHERE
key_id = 'ff38d981783c527b8324584454637842a8af1d79d8e85a3522e82549b9c71a9b'
AND (
token = '0/vnrEsEIwFiFMBot3z/eq3NyxCM80OFs8tK4sziCE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)