UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZM71/VaRurxvU+hY7W06Ceh4Tr0hDQxQpTkdIda7tVw='
WHERE
key_id = 'bb1bcfe8da4d56b6f4514212f4cb90cb1f0d25544fb1e67947f31ef5772136c5'
AND (
token = 'ZM71/VaRurxvU+hY7W06Ceh4Tr0hDQxQpTkdIda7tVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)