UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p0Djt+OasuGRgArfzWKO2ks+hjlHsm6TV1VnYaym00E='
WHERE
key_id = 'bd31ba56094825a600e8a61e29625f23d306a3ee2053c9a242160aebca9a253b'
AND (
token = 'p0Djt+OasuGRgArfzWKO2ks+hjlHsm6TV1VnYaym00E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)