UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27IU+gwoIeYc9v+sOE4xSvYI1yZ6lVsrWoO0+r3NOBc='
WHERE
key_id = '0e9faa33544d649d56fdd17ad433d53c2176fcee4b29f082c6ce1bff41b488ff'
AND (
token = '27IU+gwoIeYc9v+sOE4xSvYI1yZ6lVsrWoO0+r3NOBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)