UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BvVU3quWAzm/Ja47pTTn6jHoRs8xdlLlTLpJhlZBgK4='
WHERE
key_id = '7c8600b7388ddb3d730222710e68a6906701bfdc4b670e8748ed7b35d7da8aa0'
AND (
token = 'BvVU3quWAzm/Ja47pTTn6jHoRs8xdlLlTLpJhlZBgK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)