UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'haU6eDE7+VIihmnls5bZplU/TyExeJtvAJ7js6GzEZ0='
WHERE
key_id = 'be3e8c3c65400a2630f071c1a73856643989b7d17893d46afe8b312eb80487a5'
AND (
token = 'haU6eDE7+VIihmnls5bZplU/TyExeJtvAJ7js6GzEZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)