UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WJ6cKN/hPLw03gAa0BLi7A9lcfFTJTPlT35wp2xXzno='
WHERE
key_id = '778d1cffce42c774acc9441497e9723dd11a8c3fddeb4b310d578c070a008621'
AND (
token = 'WJ6cKN/hPLw03gAa0BLi7A9lcfFTJTPlT35wp2xXzno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)