UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fTHx0vrouLpppHVX8s6PFCGDmoBqnlH/S+m+JarWkcc='
WHERE
key_id = 'f38fd5dc324fa48f026369a28539fe4b9b40b47b7d5cba037759ffd1596a9f5a'
AND (
token = 'fTHx0vrouLpppHVX8s6PFCGDmoBqnlH/S+m+JarWkcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)