UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gk9Mja+X5JvPObVZlzPeb7tppf8IZiG7XdqlmPig5To='
WHERE
key_id = 'f7f95d59dde9dd008f27534502247d57735ef1a3b004724ca5b2d53e4427162f'
AND (
token = 'Gk9Mja+X5JvPObVZlzPeb7tppf8IZiG7XdqlmPig5To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)