UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HNSSQ0toqskYT1f45FqYgbs710G+dy2haYnOLvO3Kt8='
WHERE
key_id = '8ace556de78b89e5161ddc7d13e50cbc8a21a63eedae784a5f658cbd83431e36'
AND (
token = 'HNSSQ0toqskYT1f45FqYgbs710G+dy2haYnOLvO3Kt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)