UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oyEMyU6lMqKc9Kc9Njo4Wui5xxH/MBulHerXTomceL0='
WHERE
key_id = '9c08d30eff749a1810839415ab8cc94e926b05832200f38674185eeaa59c267b'
AND (
token = 'oyEMyU6lMqKc9Kc9Njo4Wui5xxH/MBulHerXTomceL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)