UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0bRpcLSQH247j2zWCoPgpWGi+IFmEdiiWNnag9wJWGw='
WHERE
key_id = 'de9fe49ef7bb0e157c8576ca65df4cc7f6d3126a2e7fcb280268975ee434eb78'
AND (
token = '0bRpcLSQH247j2zWCoPgpWGi+IFmEdiiWNnag9wJWGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)