UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y1sWUeJL6z4zi/uw3xyJw3jqCdSCDiJBz0sUND8mVA0='
WHERE
key_id = 'c1ae4e0292aa57c56f175d6c2c11cc42f64e5adea2f08c8f529f8232b7804a69'
AND (
token = 'y1sWUeJL6z4zi/uw3xyJw3jqCdSCDiJBz0sUND8mVA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)