UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vY4k0UUDt/oS6gPCYBICBoiYtM7BENlAAA565SDGi0Y='
WHERE
key_id = 'd6d1048478eb0fdc08d3edc677837db0dc8b920affd57f9e6d62f151de854ab9'
AND (
token = 'vY4k0UUDt/oS6gPCYBICBoiYtM7BENlAAA565SDGi0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)