UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5QgKh4r2gosen/jF6pOyW/ophqkcAbmNedl4wdC60Z0='
WHERE
key_id = '6a8f61a88e50e207c966c118b29312ab3135eb23aa94eb37a5158bafdb64f431'
AND (
token = '5QgKh4r2gosen/jF6pOyW/ophqkcAbmNedl4wdC60Z0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)