UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27EmRlOk64ZpLbpsJ/EjCrwO3S9q4dgFt/bYH3W0dMo='
WHERE
key_id = 'cbd0fbc15582acd75b8838f33fc98ac0e3530b338f3584918b899c7f3dd7cd46'
AND (
token = '27EmRlOk64ZpLbpsJ/EjCrwO3S9q4dgFt/bYH3W0dMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)