UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jn4xdqVEseVlJB2BV/dAz6DILoAG+AcCogPE6ds+k8I='
WHERE
key_id = 'a0b735f71adb9b2c8b8fd7d42b2a2cd8b2de7ab098dd29b6686de038086e4998'
AND (
token = 'jn4xdqVEseVlJB2BV/dAz6DILoAG+AcCogPE6ds+k8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)