UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THxvnGKP8zvmzCccllIWvKCEnXwvJQt8howCgIkTcDk='
WHERE
key_id = 'c2f72b5016e24c82d7e68eb9302029f4b1b9d6db73747d40c79e4ad7fae90ab3'
AND (
token = 'THxvnGKP8zvmzCccllIWvKCEnXwvJQt8howCgIkTcDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)