UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pOKkY6dTkhhwM9yGDGGf3RyFZppkWVn8JcemFFU4/5M='
WHERE
key_id = '8a41d7f5800db9057915e77bb6fdc0a6f177b21a6c0461b98852e8b2513a8977'
AND (
token = 'pOKkY6dTkhhwM9yGDGGf3RyFZppkWVn8JcemFFU4/5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)