UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c8MdLviAF/K2gwy3LZRwhvi27kmSIw3BBcDsW4m6hjs='
WHERE
key_id = '2ad4bfe8f1bc506af36cb4e7f437bf98d09c02b473b915ce04ef24b9e18b770d'
AND (
token = 'c8MdLviAF/K2gwy3LZRwhvi27kmSIw3BBcDsW4m6hjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)